Tabela CO_STOCKORDER

Definicja tabeli CO_STOCKORDER

Name

CO_STOCKORDER

Code

CO_STOCKORDER

Comment

Tabela zam??wie?? magazynowych


Lista kolumn tabeli CO_STOCKORDER

Name

Code

STOCKORDERID

STOCKORDERID

STOCKORDERSTATUSID

STOCKORDERSTATUSID

ORDERNO

ORDERNO

STOCKID

STOCKID

KITCHENID

KITCHENID

STOCKORDERDT

STOCKORDERDT

MEALDT

MEALDT

DELIVERYDT

DELIVERYDT

ACTIVE

ACTIVE

INSERTDATE

INSERTDATE

INSERTINGPERSON

INSERTINGPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDDT

LASTMODIFIEDDT

ExternalId

ExternalId


Kolumna STOCKORDERID tabeli CO_STOCKORDER

Definicja kolumny STOCKORDERID tabeli CO_STOCKORDER

Name

STOCKORDERID

Code

STOCKORDERID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

klucz g????wny


Kolumna STOCKORDERSTATUSID tabeli CO_STOCKORDER

Definicja kolumny STOCKORDERSTATUSID tabeli CO_STOCKORDER

Name

STOCKORDERSTATUSID

Code

STOCKORDERSTATUSID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ORDERNO tabeli CO_STOCKORDER

Definicja kolumny ORDERNO tabeli CO_STOCKORDER

Name

ORDERNO

Code

ORDERNO

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

numer zam??wienia


Kolumna STOCKID tabeli CO_STOCKORDER

Definicja kolumny STOCKID tabeli CO_STOCKORDER

Name

STOCKID

Code

STOCKID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

identyfikator magazynu


Kolumna KITCHENID tabeli CO_STOCKORDER

Definicja kolumny KITCHENID tabeli CO_STOCKORDER

Name

KITCHENID

Code

KITCHENID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

identyfikator kuchni, klucz obcy do CO_KITCHEN


Kolumna STOCKORDERDT tabeli CO_STOCKORDER

Definicja kolumny STOCKORDERDT tabeli CO_STOCKORDER

Name

STOCKORDERDT

Code

STOCKORDERDT

Data Type

DATE

Mandatory

Yes

Comment

data zam??wienia


Kolumna MEALDT tabeli CO_STOCKORDER

Definicja kolumny MEALDT tabeli CO_STOCKORDER

Name

MEALDT

Code

MEALDT

Data Type

DATE

Mandatory

No

Comment

data posi??k??w


Kolumna DELIVERYDT tabeli CO_STOCKORDER

Definicja kolumny DELIVERYDT tabeli CO_STOCKORDER

Name

DELIVERYDT

Code

DELIVERYDT

Data Type

DATE

Mandatory

No

Comment

data dostawy


Kolumna ACTIVE tabeli CO_STOCKORDER

Definicja kolumny ACTIVE tabeli CO_STOCKORDER

Name

ACTIVE

Code

ACTIVE

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna INSERTDATE tabeli CO_STOCKORDER

Definicja kolumny INSERTDATE tabeli CO_STOCKORDER

Name

INSERTDATE

Code

INSERTDATE

Data Type

DATE

Mandatory

No

Comment

 


Kolumna INSERTINGPERSON tabeli CO_STOCKORDER

Definicja kolumny INSERTINGPERSON tabeli CO_STOCKORDER

Name

INSERTINGPERSON

Code

INSERTINGPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDPERSON tabeli CO_STOCKORDER

Definicja kolumny LASTMODIFIEDPERSON tabeli CO_STOCKORDER

Name

LASTMODIFIEDPERSON

Code

LASTMODIFIEDPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDDT tabeli CO_STOCKORDER

Definicja kolumny LASTMODIFIEDDT tabeli CO_STOCKORDER

Name

LASTMODIFIEDDT

Code

LASTMODIFIEDDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ExternalId tabeli CO_STOCKORDER

Definicja kolumny ExternalId tabeli CO_STOCKORDER

Name

ExternalId

Code

ExternalId

Data Type

NUMBER(10)

Mandatory

No

Comment

StockOrderId w module Pharmacy


Lista kluczy tabeli CO_STOCKORDER

Name

Code

Primary

PK_CO_STOCKORDER

PK_CO_STOCKORDER

X


Klucz PK_CO_STOCKORDER tabeli CO_STOCKORDER

Definicja klucza PK_CO_STOCKORDER tabeli CO_STOCKORDER

Name

PK_CO_STOCKORDER

Code

PK_CO_STOCKORDER

Primary

Yes

Comment